UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uBC4+allZilAqQQX1ugJcOQk6OxjiZfXleuCU47aPd8='
WHERE
key_id = '76dccab87c9aa029121a9edb7be1ea0c45aef6b4b3bb19a904dfde815d707e1b'
AND (
token = 'uBC4+allZilAqQQX1ugJcOQk6OxjiZfXleuCU47aPd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)