UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NgkAMmnWscIXDAupHuoO0BrzfdzvRkIn8qDh6uXitxc='
WHERE
key_id = '20edc77b57644053b12334e04e666ead2ddcd0c15f268d5b2b1e59490dee90d1'
AND (
token = 'NgkAMmnWscIXDAupHuoO0BrzfdzvRkIn8qDh6uXitxc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)