UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NFDDS3hSyo10nq2hkkl/YVj19VWW2vpYd/va+Cory8o='
WHERE
key_id = '78bab24205da4240a69344a0a6d87a82765088e1da37c49865b780a23073750b'
AND (
token = 'NFDDS3hSyo10nq2hkkl/YVj19VWW2vpYd/va+Cory8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)