UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q6duEDp6WKPl/FTaPkOVGHaalA99TVGS2D2JO7asfCE='
WHERE
key_id = 'a21c87f71db6e9390e87aab8d83bb01f164b559a3f545765b3fb9af2f3c211a2'
AND (
token = 'q6duEDp6WKPl/FTaPkOVGHaalA99TVGS2D2JO7asfCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)