UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7lcLuJzHcVvTXm6boEfghgM49alEmP4EW/crH9vNyPQ='
WHERE
key_id = 'a3c40e4bbec7767e6e83ee8596bbe44096ff24ba839cb37d2f6eae821e1bd132'
AND (
token = '7lcLuJzHcVvTXm6boEfghgM49alEmP4EW/crH9vNyPQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)