UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VzLppbnGUE2OesxLyfoixfBKcbFlMvvRZE3JIDk63io='
WHERE
key_id = 'd9b2800c8dce557541373adb8ede9fdf50f4415c0ea6409c84576f2f21d8869b'
AND (
token = 'VzLppbnGUE2OesxLyfoixfBKcbFlMvvRZE3JIDk63io='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)