UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FnGjMyr/f0jk2uOscxR1cCieO0xaVLBr9a4J2XOq3mU='
WHERE
key_id = '1f878762bfc741bbccfaf904d7b551a30e51f9e279d389723f1c0542e25e28fd'
AND (
token = 'FnGjMyr/f0jk2uOscxR1cCieO0xaVLBr9a4J2XOq3mU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)