UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NJvLAU3wJTEhKoNvPYUH9n5HUfOaiz2gAG5wFs28JCA='
WHERE
key_id = 'f6f02028af1eb2137ff10619e0aca59588c165179ad721b23fc2a5b557a1837f'
AND (
token = 'NJvLAU3wJTEhKoNvPYUH9n5HUfOaiz2gAG5wFs28JCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)