UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5SuXKLVB7G0/rjmpe0Qr68SnKhF5/I8hlgpddt3EvWY='
WHERE
key_id = '12c7bf2be9e17c06ec36a6bced8fa8b0e780662123897a73df096ba6b70db5cc'
AND (
token = '5SuXKLVB7G0/rjmpe0Qr68SnKhF5/I8hlgpddt3EvWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)