UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ft9SQjCq6WPTF2FTvoEhaJZwuPI0Z4y7AWmxht5QpM8='
WHERE
key_id = '8d7f0336b328f7ccf5880ed986a2cdc5454cdd70101250791e0f70efdc1b14c9'
AND (
token = 'Ft9SQjCq6WPTF2FTvoEhaJZwuPI0Z4y7AWmxht5QpM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)