UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BJthihjSY9rKwKD21IgqjhJZuv/TZM7gRg4zu3nGGnw='
WHERE
key_id = 'c7ecbce27c70388360f6b94a3b4fab4918e1f9f0feb43478275fe64afd7255e5'
AND (
token = 'BJthihjSY9rKwKD21IgqjhJZuv/TZM7gRg4zu3nGGnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)