UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pQTXtYhYiYDz7LVdmvVZjYJXh4DVcF223rFvajSvZPI='
WHERE
key_id = '5739a7506e6d9cd0d947b15df9c0a7fd8859c5af6dff369057b4875703b96fd2'
AND (
token = 'pQTXtYhYiYDz7LVdmvVZjYJXh4DVcF223rFvajSvZPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)