UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OzV+GcCGMQZX36g5gsyv1xkRX0e2+c75FCqXWF+LLvY='
WHERE
key_id = 'c3ec161bc531ff3727b1c29fe499201da760f6af87c7aade1a74cc600b84a358'
AND (
token = 'OzV+GcCGMQZX36g5gsyv1xkRX0e2+c75FCqXWF+LLvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)