UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HxcgefBz7XXE65t8Y1ysLS6Bu6MuXLyOa/18NJ/bKII='
WHERE
key_id = 'f2d3b218008fa6a227f4cfee6957d712796a672e26d2fd922c3469f37bab5b53'
AND (
token = 'HxcgefBz7XXE65t8Y1ysLS6Bu6MuXLyOa/18NJ/bKII='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)