UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dfEZb+CxDVuI8eszzRpuZfmN2MXp3DbEFQBFJzAI/DM='
WHERE
key_id = '476e4ce306cbde1ac0af8a9c99d71536c9baefb3ba9351e3ac8c5b3a4e060fa9'
AND (
token = 'dfEZb+CxDVuI8eszzRpuZfmN2MXp3DbEFQBFJzAI/DM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)