UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1f7F8cjyDSWz2AUsBh+mGyU6OljUfEyOPWjQxVtWAO0='
WHERE
key_id = '04c39e77e12594b2e403ea65b2ab07ace2e72ca0eb240232d1e7f981621abd98'
AND (
token = '1f7F8cjyDSWz2AUsBh+mGyU6OljUfEyOPWjQxVtWAO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)