UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dkl0nafiOV1aSg8xYQkw83xdJLyOl9togAiE1m+KoNo='
WHERE
key_id = 'd3dbc896d37b548437330a22b8488790ea2334769db4500c490db3b0d62d6147'
AND (
token = 'Dkl0nafiOV1aSg8xYQkw83xdJLyOl9togAiE1m+KoNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)