UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PBG69jRnt1umnJXOvnVm2bPFBfEiYX6CrhBUjf9KwT0='
WHERE
key_id = '0d1e39015a2a9c681188570221c15a400c4877495830b0ff252ef200eba582a6'
AND (
token = 'PBG69jRnt1umnJXOvnVm2bPFBfEiYX6CrhBUjf9KwT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)