UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HTtmK9x5BaHMLF9JVYtRSHi7Xbxqgi5TLbeaVA5Wp5M='
WHERE
key_id = '7cb7fc1e1dc6bae7dbbffdc1a1497d5d57d1b13df3f8e8dae5483b9c6a900347'
AND (
token = 'HTtmK9x5BaHMLF9JVYtRSHi7Xbxqgi5TLbeaVA5Wp5M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)