UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v4rM8w8i6+a1cHc6OHsCgD4/rghhH6tde/9fRVRVdG4='
WHERE
key_id = '8ade3d9045a3124adeefbcc1d3d168adb737670acea45216e252438f8a02d99b'
AND (
token = 'v4rM8w8i6+a1cHc6OHsCgD4/rghhH6tde/9fRVRVdG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)