UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mGuB4NG8HJJxLW2Y/FxAgiyZzoCsn6Kwycd/iOjOFx8='
WHERE
key_id = 'c3dd793bee542b62fca40244a81f7eaa6c56ad56cbc41ad328782de3aedced98'
AND (
token = 'mGuB4NG8HJJxLW2Y/FxAgiyZzoCsn6Kwycd/iOjOFx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)