UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3X1o/1DNiMPljuowhQEt8rYDRxhdChNkyZtxowhYYjU='
WHERE
key_id = 'b0d923d44184d98b492b66c9fbdc56c7ee0d7df3ec881d71d661783ce2fc0b5a'
AND (
token = '3X1o/1DNiMPljuowhQEt8rYDRxhdChNkyZtxowhYYjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)