UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BSkGJxhijEKP9wPUPgzpP5sneHhCeUSbBe0HqSYKfxk='
WHERE
key_id = '11bcca97a65aa18a940d2bf4d4c03a54e8e0ca899634cbfe92fb35a17728272a'
AND (
token = 'BSkGJxhijEKP9wPUPgzpP5sneHhCeUSbBe0HqSYKfxk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)