UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lvZNpy7WFrlCHAtXzx2BIKx6h83RioG33DHhtZzWzsM='
WHERE
key_id = '6961204469d3234962fcf2e4990c7de6206d7b917c594de3c1c33177b207bfc5'
AND (
token = 'lvZNpy7WFrlCHAtXzx2BIKx6h83RioG33DHhtZzWzsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)