UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Sc7JFFQE6E5MqMsxE1bDEM40vsW8pAoh4a8Hr4HOFk='
WHERE
key_id = '5887af13995a8e0211b92cdb29aaae39bf0c6864c35f71cdca06398088e90f7c'
AND (
token = '6Sc7JFFQE6E5MqMsxE1bDEM40vsW8pAoh4a8Hr4HOFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)