UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jp6GgrBLc+zhGh92S+okSkJTUdwypHP+A6kSJeODEvM='
WHERE
key_id = '527d3795940d7a8930cb9a5771887f1139457a963f632c89a98e8ad4d9ff6801'
AND (
token = 'Jp6GgrBLc+zhGh92S+okSkJTUdwypHP+A6kSJeODEvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)