UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k8242+w8Ze1dFVBj0oF+RU0V0gnmtkRRma6/L4q4XBQ='
WHERE
key_id = 'a770260d913a1af9168915e3fcef28426b3b75aa37c2d1d74b5f562021ade702'
AND (
token = 'k8242+w8Ze1dFVBj0oF+RU0V0gnmtkRRma6/L4q4XBQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)