UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J8yJZZmzCPyz5ZsM0ZX/6VRvn0czrs4OcVWY85VSFD4='
WHERE
key_id = 'b583a2706a3408cd935a845a70c3f6ecd1294d3ceba39e0391486193c896088f'
AND (
token = 'J8yJZZmzCPyz5ZsM0ZX/6VRvn0czrs4OcVWY85VSFD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)