UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lKM8HRJmtLjKNjL7ltA/KIyXBttZ3ImPLNxoP+ro5/E='
WHERE
key_id = 'd39d6e101d7ab096148f34cf0f11568adc34b83fa397e5c6afab7183116260ae'
AND (
token = 'lKM8HRJmtLjKNjL7ltA/KIyXBttZ3ImPLNxoP+ro5/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)