UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9kQzlCdmABN5vWjTRk8xUn9yntoQeqyIPN7ozrqo7rA='
WHERE
key_id = '2b660c602eef8518b4e69a60d54e813da45fa197f94a111a18d17139654ce67c'
AND (
token = '9kQzlCdmABN5vWjTRk8xUn9yntoQeqyIPN7ozrqo7rA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)