UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'josHSt9acGAgY1PJ41cJDvVEfrCY6a7qjvLYbcQOGJo='
WHERE
key_id = '643ab1e3b37dbe458977edc224feb3708e079727ddefcf9e21634aa9c8182bc7'
AND (
token = 'josHSt9acGAgY1PJ41cJDvVEfrCY6a7qjvLYbcQOGJo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)