UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HvB/0BiknhAVeHIH4whr8FT8cqrLeItOt8dr76qIe7s='
WHERE
key_id = 'ed80021b980ac1ef82e90235194d99bafde2c4d5d5e7406057a529c8b4f7c433'
AND (
token = 'HvB/0BiknhAVeHIH4whr8FT8cqrLeItOt8dr76qIe7s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)