UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dOt23o8TnVKOPvkIJy+HHaDOcD0namD94070uq27SK4='
WHERE
key_id = 'bc0c7e1b142152ee6cf06f7edc6ba299739ba2550c5b4137148ae3b288eba417'
AND (
token = 'dOt23o8TnVKOPvkIJy+HHaDOcD0namD94070uq27SK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)