UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q3/o1wCCi99FSVt83o7Nvey6KjTvVgTij2zQtbHtE1s='
WHERE
key_id = 'a787c9b106c7251e92c2c902447c1a9b7ef6d70d689c75acc5a2d2252b81848b'
AND (
token = 'q3/o1wCCi99FSVt83o7Nvey6KjTvVgTij2zQtbHtE1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)