UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p5abFSB4jHI5fQi6QmZQ9reo0xqbjwGtBgVzALIHTYQ='
WHERE
key_id = '309fe263381576f1b67f8ea0854a65b670e2ed4be6257aed5b83f382b0b9c366'
AND (
token = 'p5abFSB4jHI5fQi6QmZQ9reo0xqbjwGtBgVzALIHTYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)