UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K5QvqNL8bYPb5catyxwDf7F6qVsydy34rPa5Q61dLfY='
WHERE
key_id = 'e2ed31646bd35bde9c305dabc2b79ce04537a6b6643ae639907281c1debafd29'
AND (
token = 'K5QvqNL8bYPb5catyxwDf7F6qVsydy34rPa5Q61dLfY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)