UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OBawvzWIIBnwFg9DPK0rUDjWKVrdIUsfSMpF3CUZYPU='
WHERE
key_id = '1c9bf93f40297fb8e850e22f226a819d50d23cfc97476fcafc6018db2fb750c3'
AND (
token = 'OBawvzWIIBnwFg9DPK0rUDjWKVrdIUsfSMpF3CUZYPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)