UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JgKts8T8zgk545b0y/23NmHkejfGUk0NXjESnyJDBwo='
WHERE
key_id = 'bf26559bfee983923a23a80694ca1fb9f6a87e9d985275a3c596e932fd5c3992'
AND (
token = 'JgKts8T8zgk545b0y/23NmHkejfGUk0NXjESnyJDBwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)